using System;
using System.Collections;
using System.Data;
using System.Data.OleDb;
public class QQInviteUtil
{
	private OleDbCommand oleDbCommand_0;
	private OleDbCommand oleDbCommand_1;
	private OleDbCommand oleDbCommand_10;
	private OleDbCommand oleDbCommand_11;
	private OleDbCommand oleDbCommand_12;
	private OleDbCommand oleDbCommand_13;
	private OleDbCommand oleDbCommand_14;
	private OleDbCommand oleDbCommand_15;
	private OleDbCommand oleDbCommand_16;
	private OleDbCommand oleDbCommand_17;
	private OleDbCommand oleDbCommand_18;
	private OleDbCommand oleDbCommand_19;
	private OleDbCommand oleDbCommand_2;
	private OleDbCommand oleDbCommand_20;
	public OleDbCommand oleDbCommand_21;
	private OleDbCommand oleDbCommand_3;
	private OleDbCommand oleDbCommand_4;
	private OleDbCommand oleDbCommand_5;
	private OleDbCommand oleDbCommand_6;
	private OleDbCommand oleDbCommand_7;
	private OleDbCommand oleDbCommand_8;
	private OleDbCommand oleDbCommand_9;
	public OleDbConnection oleDbConnection_0;
	public string string_0 = "";
	public void method_0()
	{
		if (this.oleDbConnection_0 == null)
		{
			string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + this.string_0;
			this.oleDbConnection_0 = new OleDbConnection(connectionString);
			this.oleDbConnection_0.Open();
		}
	}
	public void method_1()
	{
		try
		{
			this.oleDbConnection_0.Close();
			this.oleDbConnection_0.Dispose();
		}
		catch (Exception)
		{
		}
	}
	public bool delete_qq_qun(QQqun qq_qun, out string out_log)
	{
		bool result;
		try
		{
			string text = "delete from qqgroupmng where qqgroup='{qqgroup}';";
			text = text.Replace("{qqgroup}", qq_qun.num);
			result = this.method_7(text, out out_log);
		}
		catch (Exception ex)
		{
			out_log = ex.ToString();
			result = false;
		}
		return result;
	}
	public ArrayList query_qq_qun(string string_1, out string string_2)
	{
		OleDbDataReader oleDbDataReader = null;
		ArrayList result;
		try
		{
			ArrayList arrayList = new ArrayList();
			this.oleDbCommand_7 = this.method_38(this.oleDbCommand_7, string_1);
			oleDbDataReader = this.oleDbCommand_7.ExecuteReader();
			while (oleDbDataReader.Read())
			{
				arrayList.Add(new QQqun
				{
					num = oleDbDataReader["qqgroup"].ToString(),
					name = oleDbDataReader["groupname"].ToString(),
					owner = oleDbDataReader["owner"].ToString()
				});
			}
			string_2 = "";
			result = arrayList;
		}
		catch (Exception ex)
		{
			string_2 = ex.ToString();
			result = null;
		}
		finally
		{
			this.method_23(oleDbDataReader);
		}
		return result;
	}
	public bool method_12(Aliorder aliorder)
	{
		bool result;
		try
		{
			string text = "INSERT INTO aliorder(oid,taobaoTradeId, auctionId, auctionTitle, exShopTitle, payStatus, auctionNum,  totalAlipayFeeString, feeString, discountAndSubsidyToString, tbTradeCreateTime, payPubTime, terminalType, alimamaAccount, qq, refundAmount, extRefundAmount, refundStatus, refundId, updflg) VALUES ({oid},'{taobaoTradeId}', '{auctionId}', '{auctionTitle}', '{exShopTitle}', {payStatus}, {auctionNum}, '{totalAlipayFeeString}', '{feeString}', '{discountAndSubsidyToString}', '{tbTradeCreateTime}', '{payPubTime}', '{terminalType}', '{alimamaAccount}', '{qq}', {refundAmount}, {extRefundAmount}, {refundStatus}, {refundId}, {updflg});";
			text = text.Replace("{oid}", string.Concat(aliorder.id)).Replace("{taobaoTradeId}", aliorder.taobaoTradeId).Replace("{auctionId}", aliorder.num_iid).Replace("{auctionTitle}", aliorder.title.Replace("'", "").Replace("\n", "").Replace("\t", "")).Replace("{exShopTitle}", aliorder.shop_title.Replace("'", "").Replace("\n", "").Replace("\t", "")).Replace("{payStatus}", string.Concat(aliorder.payStatus)).Replace("{auctionNum}", string.Concat(aliorder.auctionNum)).Replace("{totalAlipayFeeString}", aliorder.totalAlipayFeeString).Replace("{feeString}", aliorder.feeString).Replace("{discountAndSubsidyToString}", aliorder.discountAndSubsidyToString).Replace("{tbTradeCreateTime}", aliorder.tbTradeCreateTime).Replace("{payPubTime}", aliorder.payPubTime).Replace("{terminalType}", aliorder.terminalType).Replace("{alimamaAccount}", aliorder.alimamaAccount).Replace("{qq}", aliorder.qq).Replace("{refundAmount}", string.Concat(aliorder.refundAmount)).Replace("{extRefundAmount}", string.Concat(aliorder.extRefundAmount)).Replace("{refundStatus}", string.Concat(aliorder.refundStatus)).Replace("{refundId}", string.Concat(aliorder.refundId)).Replace("{updflg}", string.Concat(aliorder.updfl));
			this.oleDbCommand_8 = this.method_38(this.oleDbCommand_8, text);
			this.oleDbCommand_8.ExecuteNonQuery();
			result = true;
		}
		catch
		{
			result = false;
		}
		return result;
	}
	public string method_13(Aliorder aliorder)
	{
		string text = "INSERT INTO aliorder_refund_bak(oid,taobaoTradeId, auctionId, auctionTitle, exShopTitle, payStatus, auctionNum,  totalAlipayFeeString, feeString, discountAndSubsidyToString, tbTradeCreateTime, payPubTime, terminalType, alimamaAccount, qq, refundAmount, extRefundAmount, refundStatus, refundId, updflg) VALUES ({oid},'{taobaoTradeId}', '{auctionId}', '{auctionTitle}', '{exShopTitle}', {payStatus}, {auctionNum}, '{totalAlipayFeeString}', '{feeString}', '{discountAndSubsidyToString}', '{tbTradeCreateTime}', '{payPubTime}', '{terminalType}', '{alimamaAccount}', '{qq}', {refundAmount}, {extRefundAmount}, {refundStatus}, {refundId}, {updflg});";
		return text.Replace("{oid}", string.Concat(aliorder.id)).Replace("{taobaoTradeId}", aliorder.taobaoTradeId).Replace("{auctionId}", aliorder.num_iid).Replace("{auctionTitle}", aliorder.title.Replace("'", "").Replace("\n", "").Replace("\t", "")).Replace("{exShopTitle}", aliorder.shop_title.Replace("'", "").Replace("\n", "").Replace("\t", "")).Replace("{payStatus}", string.Concat(aliorder.payStatus)).Replace("{auctionNum}", string.Concat(aliorder.auctionNum)).Replace("{totalAlipayFeeString}", aliorder.totalAlipayFeeString).Replace("{feeString}", aliorder.feeString).Replace("{discountAndSubsidyToString}", aliorder.discountAndSubsidyToString).Replace("{tbTradeCreateTime}", aliorder.tbTradeCreateTime).Replace("{payPubTime}", aliorder.payPubTime).Replace("{terminalType}", aliorder.terminalType).Replace("{alimamaAccount}", aliorder.alimamaAccount).Replace("{qq}", aliorder.qq).Replace("{refundAmount}", string.Concat(aliorder.refundAmount)).Replace("{extRefundAmount}", string.Concat(aliorder.extRefundAmount)).Replace("{refundStatus}", string.Concat(aliorder.refundStatus)).Replace("{refundId}", string.Concat(aliorder.refundId)).Replace("{updflg}", string.Concat(aliorder.int_7));
	}
	public bool method_14(ArrayList arrayList_0, out string string_1)
	{
		bool result;
		try
		{
			string text = "update aliorder set refundStatus=1, refundDateTime='{refundDateTime}', updflg=0 where oid={oid}; ";
			foreach (Aliorder aliorder in arrayList_0)
			{
				string newValue = DateTime.Now.ToString("yyyyMMddHHmm");
				string string_2 = text.Replace("{refundDateTime}", newValue).Replace("{oid}", string.Concat(aliorder.id));
				this.oleDbCommand_9 = this.method_38(this.oleDbCommand_9, string_2);
				this.oleDbCommand_9.ExecuteNonQuery();
				aliorder.payStatus = 1;
				aliorder.int_6 = 1;
				this.oleDbCommand_9.CommandText = this.method_13(aliorder);
				this.oleDbCommand_9.ExecuteNonQuery();
			}
			string_1 = "";
			result = true;
		}
		catch (Exception ex)
		{
			string_1 = ex.ToString();
			result = false;
		}
		return result;
	}
	public bool method_15(string string_1)
	{
		bool result;
		try
		{
			this.oleDbCommand_10 = this.method_38(this.oleDbCommand_10, string_1);
			this.oleDbCommand_10.ExecuteNonQuery();
			result = true;
		}
		catch
		{
			result = false;
		}
		return result;
	}
	public bool delete_order(PayOrder payOrder, out string string_1)
	{
		bool result;
		try
		{
			string text = "delete from aliorder where oid={oid};";
			text = text.Replace("{oid}", string.Concat(payOrder.id));
			string_1 = "";
			result = this.method_15(text);
		}
		catch (Exception ex)
		{
			string_1 = ex.ToString();
			result = false;
		}
		return result;
	}
	public ArrayList query_order(int int_0, out string out_log)
	{
		string string_ = "select * from aliorder where oid=" + int_0 + ";";
		return this.method_21(string_, out out_log);
	}
	public ArrayList method_18(string taobao_no, out string string_2)
	{
		string string_3 = "select * from aliorder where taobaoTradeId like '" + taobao_no + "';";
		return this.method_21(string_3, out string_2);
	}
	public ArrayList method_19(string string_1, out string string_2)
	{
		string string_3 = "select * from aliorder where auctionId='" + string_1 + "';";
		return this.method_21(string_3, out string_2);
	}
	public bool method_2(QQgroupinvite qqgroupinvite, out string string_1)
	{
		bool result;
		try
		{
			string text = "insert into qqgroupinvite(qid, qqgroup, qq, inviteqq, authadimqq, ingroupflg, exitflg, deladmin, entertime, exittime) values({qid}, '{qqgroup}', '{qq}', '{inviteqq}', '{authadimqq}', '{ingroupflg}', '{exitflg}', '{deladmin}', '{entertime}', '{exittime}');";
			text = text.Replace("{qid}", qqgroupinvite.id ?? "").Replace("{qqgroup}", qqgroupinvite.qqgroup).Replace("{qq}", qqgroupinvite.qq).Replace("{inviteqq}", qqgroupinvite.inviteqq).Replace("{authadimqq}", qqgroupinvite.authadimqq).Replace("{ingroupflg}", qqgroupinvite.ingroupflg).Replace("{exitflg}", qqgroupinvite.exitflg).Replace("{deladmin}", qqgroupinvite.deladmin).Replace("{entertime}", qqgroupinvite.exittime).Replace("{exittime}", qqgroupinvite.exittime);
			this.oleDbCommand_0 = this.method_38(this.oleDbCommand_0, text);
			this.oleDbCommand_0.ExecuteNonQuery();
			string_1 = "";
			result = true;
		}
		catch (Exception ex)
		{
			string_1 = ex.ToString();
			result = false;
		}
		return result;
	}
	public ArrayList method_20(string string_1, out string string_2)
	{
		string string_3 = "select * from aliorder where qq='" + string_1 + "';";
		return this.method_21(string_3, out string_2);
	}
	public ArrayList method_21(string string_1, out string string_2)
	{
		OleDbDataReader oleDbDataReader = null;
		ArrayList result;
		try
		{
			ArrayList arrayList = new ArrayList();
			this.oleDbCommand_11 = this.method_38(this.oleDbCommand_11, string_1);
			oleDbDataReader = this.oleDbCommand_11.ExecuteReader();
			while (oleDbDataReader.Read())
			{
				Aliorder value = this.method_24(oleDbDataReader);
				arrayList.Add(value);
			}
			string_2 = "";
			result = arrayList;
		}
		catch (Exception ex)
		{
			string_2 = ex.ToString();
			result = null;
		}
		finally
		{
			this.method_23(oleDbDataReader);
		}
		return result;
	}
	public ArrayList method_22(string string_1, out string string_2)
	{
		OleDbDataReader oleDbDataReader = null;
		ArrayList result;
		try
		{
			ArrayList arrayList = new ArrayList();
			this.oleDbCommand_12 = this.method_38(this.oleDbCommand_12, string_1);
			oleDbDataReader = this.oleDbCommand_12.ExecuteReader();
			while (oleDbDataReader.Read())
			{
				arrayList.Add(new GClass35
				{
					string_0 = oleDbDataReader["qq"].ToString(),
					int_0 = int.Parse(oleDbDataReader["odrnum"].ToString()),
					float_0 = float.Parse(oleDbDataReader["odrpoi"].ToString())
				});
			}
			string_2 = "";
			result = arrayList;
		}
		catch (Exception ex)
		{
			string_2 = ex.ToString();
			result = null;
		}
		finally
		{
			this.method_23(oleDbDataReader);
		}
		return result;
	}
	public void method_23(OleDbDataReader oleDbDataReader_0)
	{
		try
		{
			oleDbDataReader_0.Close();
			oleDbDataReader_0.Dispose();
		}
		catch
		{
		}
	}
	private Aliorder method_24(OleDbDataReader oleDbDataReader_0)
	{
		Aliorder aliorder = new Aliorder();
		aliorder.id = int.Parse(oleDbDataReader_0["oid"].ToString());
		aliorder.taobaoTradeId = oleDbDataReader_0["taobaoTradeId"].ToString();
		aliorder.num_iid = oleDbDataReader_0["auctionId"].ToString();
		aliorder.title = oleDbDataReader_0["auctionTitle"].ToString();
		aliorder.shop_title = oleDbDataReader_0["exShopTitle"].ToString();
		aliorder.payStatus = int.Parse(oleDbDataReader_0["payStatus"].ToString());
		aliorder.auctionNum = int.Parse(oleDbDataReader_0["auctionNum"].ToString());
		aliorder.totalAlipayFeeString = oleDbDataReader_0["totalAlipayFeeString"].ToString();
		aliorder.feeString = oleDbDataReader_0["feeString"].ToString();
		aliorder.discountAndSubsidyToString = oleDbDataReader_0["discountAndSubsidyToString"].ToString();
		aliorder.tbTradeCreateTime = oleDbDataReader_0["tbTradeCreateTime"].ToString();
		aliorder.payPubTime = oleDbDataReader_0["payPubTime"].ToString();
		aliorder.terminalType = oleDbDataReader_0["terminalType"].ToString();
		aliorder.qq = oleDbDataReader_0["qq"].ToString();
		aliorder.alimamaAccount = oleDbDataReader_0["alimamaAccount"].ToString();
		aliorder.refundAmount = int.Parse(oleDbDataReader_0["refundAmount"].ToString());
		aliorder.extRefundAmount = int.Parse(oleDbDataReader_0["extRefundAmount"].ToString());
		try
		{
			aliorder.refundStatus = int.Parse(oleDbDataReader_0["refundStatus"].ToString());
		}
		catch
		{
			aliorder.refundStatus = 0;
		}
		aliorder.updfl = int.Parse(oleDbDataReader_0["updflg"].ToString());
		return aliorder;
	}
	public bool method_25(QQuser qquser, out string string_1)
	{
		bool result;
		try
		{
			string text = "INSERT INTO qquser(qq, uname, uaddr, alipay, telno, balance, refundamount, referqq, uremark, updflg) VALUES ('{qq}', '{uname}', '{uaddr}', '{alipay}', '{telno}', {balance}, {refundamount}, '{referqq}', '{uremark}', {updflg});";
			text = text.Replace("{qq}", qquser.qq).Replace("{uname}", qquser.uname).Replace("{uaddr}", qquser.uaddr).Replace("{alipay}", qquser.alipay).Replace("{telno}", qquser.telno).Replace("{balance}", string.Concat(qquser.balance)).Replace("{refundamount}", string.Concat(qquser.refundamount)).Replace("{referqq}", qquser.referqq).Replace("{uremark}", qquser.uremark).Replace("{updflg}", string.Concat(qquser.updflg));
			this.oleDbCommand_13 = this.method_38(this.oleDbCommand_13, text);
			this.oleDbCommand_13.ExecuteNonQuery();
			string_1 = "";
			result = true;
		}
		catch (Exception ex)
		{
			string_1 = ex.ToString();
			result = false;
		}
		return result;
	}
	public bool method_26(string string_1)
	{
		bool result;
		try
		{
			this.oleDbCommand_14 = this.method_38(this.oleDbCommand_14, string_1);
			this.oleDbCommand_14.ExecuteNonQuery();
			result = true;
		}
		catch
		{
			result = false;
		}
		return result;
	}
	public bool method_27(QQuser qquser, out string out_log)
	{
		bool result;
		try
		{
			string text = "delete from qquser where qq='{qq}';";
			text = text.Replace("{qq}", qquser.qq);
			out_log = "";
			result = this.method_26(text);
		}
		catch (Exception ex)
		{
			out_log = ex.ToString();
			result = false;
		}
		return result;
	}
	public ArrayList method_28(string string_1, out string string_2)
	{
		OleDbDataReader oleDbDataReader = null;
		ArrayList result;
		try
		{
			ArrayList arrayList = new ArrayList();
			this.oleDbCommand_15 = this.method_38(this.oleDbCommand_15, string_1);
			oleDbDataReader = this.oleDbCommand_15.ExecuteReader();
			while (oleDbDataReader.Read())
			{
				QQuser qQuser = new QQuser();
				qQuser.qq = oleDbDataReader["qq"].ToString();
				qQuser.uname = oleDbDataReader["uname"].ToString();
				qQuser.uaddr = oleDbDataReader["uaddr"].ToString();
				qQuser.alipay = oleDbDataReader["alipay"].ToString();
				qQuser.telno = oleDbDataReader["telno"].ToString();
				try
				{
					qQuser.balance = int.Parse(oleDbDataReader["balance"].ToString());
				}
				catch
				{
					qQuser.balance = 0;
				}
				try
				{
					qQuser.refundamount = int.Parse(oleDbDataReader["refundamount"].ToString());
				}
				catch
				{
					qQuser.refundamount = 0;
				}
				qQuser.referqq = oleDbDataReader["referqq"].ToString();
				qQuser.uremark = oleDbDataReader["uremark"].ToString();
				try
				{
					qQuser.updflg = int.Parse(oleDbDataReader["updflg"].ToString());
				}
				catch
				{
					qQuser.updflg = 0;
				}
				arrayList.Add(qQuser);
			}
			this.method_23(oleDbDataReader);
			if (arrayList.Count != 0)
			{
				string str = this.method_32(arrayList);
				string string_3 = "select qq,sum(refundAmount) as allrefund from aliorder where qq in (" + str + ")  and ( payStatus=14 or payStatus=3 ) and refundStatus=0 group by qq";
				this.oleDbCommand_15 = this.method_38(this.oleDbCommand_15, string_3);
				oleDbDataReader = this.oleDbCommand_15.ExecuteReader();
				while (oleDbDataReader.Read())
				{
					string string_4 = oleDbDataReader["qq"].ToString();
					int num = 0;
					try
					{
						num = int.Parse(oleDbDataReader["allrefund"].ToString());
					}
					catch
					{
					}
					QQuser qQuser = this.method_31(string_4, arrayList);
					qQuser.refundamount = num - qQuser.refundamount;
				}
				this.method_23(oleDbDataReader);
				string_3 = "select qq,sum(refundAmount) as payed from aliorder where qq in (" + str + ")  and payStatus=12  group by qq";
				this.oleDbCommand_15 = this.method_38(this.oleDbCommand_15, string_3);
				oleDbDataReader = this.oleDbCommand_15.ExecuteReader();
				while (oleDbDataReader.Read())
				{
					string string_4 = oleDbDataReader["qq"].ToString();
					int refundamount = 0;
					try
					{
						refundamount = int.Parse(oleDbDataReader["payed"].ToString());
					}
					catch
					{
					}
					this.method_31(string_4, arrayList).refundamount = refundamount;
				}
			}
			string_2 = "";
			result = arrayList;
		}
		catch (Exception ex)
		{
			string_2 = ex.ToString();
			result = null;
		}
		finally
		{
			this.method_23(oleDbDataReader);
		}
		return result;
	}
	public ArrayList method_29(string string_1, out string string_2)
	{
		OleDbDataReader oleDbDataReader = null;
		ArrayList result;
		try
		{
			ArrayList arrayList = new ArrayList();
			this.oleDbCommand_16 = this.method_38(this.oleDbCommand_16, string_1);
			oleDbDataReader = this.oleDbCommand_16.ExecuteReader();
			while (oleDbDataReader.Read())
			{
				arrayList.Add(new GClass32
				{
					int_0 = int.Parse(oleDbDataReader["ID"].ToString()),
					string_0 = oleDbDataReader["qq"].ToString(),
					float_0 = float.Parse(oleDbDataReader["refundamount"].ToString()),
					string_1 = oleDbDataReader["refunddatetime"].ToString(),
					string_2 = oleDbDataReader["remark"].ToString(),
					int_1 = int.Parse(oleDbDataReader["updflg"].ToString())
				});
			}
			string_2 = "";
			result = arrayList;
		}
		catch (Exception ex)
		{
			string_2 = ex.ToString();
			result = null;
		}
		finally
		{
			this.method_23(oleDbDataReader);
		}
		return result;
	}
	public bool method_3(QQgroupinvite qqgroupinvite, out string string_1)
	{
		bool result;
		try
		{
			string text = "delete from qqgroupinvite where qid={qid};";
			text = text.Replace("{qid}", qqgroupinvite.id);
			string_1 = "";
			result = this.method_7(text, out string_1);
		}
		catch (Exception ex)
		{
			string_1 = ex.ToString();
			result = false;
		}
		return result;
	}
	public bool method_30(GClass32 gclass32_0, out string string_1)
	{
		bool result;
		try
		{
			string text = "INSERT INTO refund(qq, refundamount, refunddatetime, remark, updflg) VALUES ('{qq}', {refundamount}, '{refunddatetime}', '{remark}', {updflg});";
			text = text.Replace("{qq}", gclass32_0.string_0).Replace("{refundamount}", string.Concat(gclass32_0.float_0)).Replace("{refunddatetime}", gclass32_0.string_1).Replace("{remark}", gclass32_0.string_2.Replace("'", "").Replace("\n", "").Replace("\t", "")).Replace("{updflg}", string.Concat(gclass32_0.int_1));
			this.oleDbCommand_17 = this.method_38(this.oleDbCommand_17, text);
			this.oleDbCommand_17.ExecuteNonQuery();
			string_1 = "";
			result = true;
		}
		catch (Exception ex)
		{
			string_1 = ex.ToString();
			result = false;
		}
		return result;
	}
	public QQuser method_31(string string_1, ArrayList arrayList_0)
	{
		foreach (QQuser qQuser in arrayList_0)
		{
			if (qQuser.qq.Equals(string_1))
			{
				return qQuser;
			}
		}
		return null;
	}
	public string method_32(ArrayList arrayList_0)
	{
		string result;
		try
		{
			string text = "";
			foreach (QQuser qQuser in arrayList_0)
			{
				if (text.Equals(""))
				{
					text = "'" + qQuser.qq + "'";
				}
				else
				{
					text = text + ", '" + qQuser.qq + "'";
				}
			}
			result = text;
		}
		catch (Exception)
		{
			result = null;
		}
		return result;
	}
	public ArrayList method_33(ArrayList arrayList_0, out string string_1)
	{
		if (arrayList_0.Count == 0)
		{
			string_1 = "";
			return arrayList_0;
		}
		this.method_37(out string_1);
		OleDbDataReader oleDbDataReader = null;
		ArrayList result;
		try
		{
			string str = this.method_32(arrayList_0);
			string string_2 = "select qq,sum(poiamount) as allpoi from adduserpoi where qq in (" + str + ") group by qq";
			this.oleDbCommand_18 = this.method_38(this.oleDbCommand_18, string_2);
			oleDbDataReader = this.oleDbCommand_18.ExecuteReader();
			while (oleDbDataReader.Read())
			{
				string string_3 = oleDbDataReader["qq"].ToString();
				int num = 0;
				try
				{
					num = int.Parse(oleDbDataReader["allpoi"].ToString());
				}
				catch
				{
				}
				QQuser qQuser = this.method_31(string_3, arrayList_0);
				qQuser.refundamount += num;
			}
			string_1 = "";
			result = arrayList_0;
		}
		catch (Exception ex)
		{
			string_1 = ex.ToString();
			result = null;
		}
		finally
		{
			this.method_23(oleDbDataReader);
		}
		return result;
	}
	public ArrayList method_34(string string_1, out string string_2)
	{
		this.method_37(out string_2);
		OleDbDataReader oleDbDataReader = null;
		ArrayList result;
		try
		{
			ArrayList arrayList = new ArrayList();
			this.oleDbCommand_19 = this.method_38(this.oleDbCommand_19, string_1);
			oleDbDataReader = this.oleDbCommand_19.ExecuteReader();
			while (oleDbDataReader.Read())
			{
				arrayList.Add(new GClass33
				{
					string_0 = oleDbDataReader["qq"].ToString(),
					string_1 = oleDbDataReader["poidatetime"].ToString(),
					float_0 = float.Parse(oleDbDataReader["poiamount"].ToString()),
					string_2 = oleDbDataReader["remark"].ToString(),
					int_0 = int.Parse(oleDbDataReader["updflg"].ToString())
				});
			}
			string_2 = "";
			result = arrayList;
		}
		catch (Exception ex)
		{
			string_2 = ex.ToString();
			result = null;
		}
		finally
		{
			this.method_23(oleDbDataReader);
		}
		return result;
	}
	public bool method_35(GClass33 gclass33_0, out string string_1)
	{
		bool result;
		try
		{
			this.method_37(out string_1);
			string text = "INSERT INTO adduserpoi(qq, poidatetime, poiamount, remark, updflg) VALUES ('{qq}', '{poidatetime}', {poiamount}, '{remark}', {updflg});";
			text = text.Replace("{qq}", gclass33_0.string_0).Replace("{poidatetime}", gclass33_0.string_1).Replace("{poiamount}", string.Concat(gclass33_0.float_0)).Replace("{remark}", gclass33_0.string_2.Replace("'", "").Replace("\n", "").Replace("\t", "")).Replace("{updflg}", string.Concat(gclass33_0.int_0));
			this.oleDbCommand_20 = this.method_38(this.oleDbCommand_20, text);
			this.oleDbCommand_20.ExecuteNonQuery();
			string_1 = "";
			result = true;
		}
		catch (Exception ex)
		{
			string_1 = ex.ToString();
			result = false;
		}
		return result;
	}
	public bool method_36(string string_1, out string string_2)
	{
		bool result;
		try
		{
			string string_3 = "select count(1) from " + string_1;
			this.oleDbCommand_21 = this.method_38(this.oleDbCommand_21, string_3);
			this.oleDbCommand_21.ExecuteReader().Close();
			string_2 = "";
			result = true;
		}
		catch
		{
			string_2 = "";
			result = false;
		}
		return result;
	}
	public void method_37(out string string_1)
	{
		if (!this.method_36("adduserpoi", out string_1))
		{
			string string_2 = "CREATE TABLE adduserpoi (qq varchar(30) NOT NULL,poidatetime varchar(100) NOT NULL, poiamount varchar(30) NOT NULL, remark varchar(255) NOT NULL, updflg number NOT NULL,  PRIMARY KEY (qq,poidatetime) ) ";
			this.method_7(string_2, out string_1);
		}
	}
	public OleDbCommand method_38(OleDbCommand oleDbCommand_22, string string_1)
	{
		if (this.oleDbConnection_0 == null)
		{
			this.method_0();
		}
		if (oleDbCommand_22 == null || oleDbCommand_22.Connection == null || oleDbCommand_22.Connection.State != ConnectionState.Open)
		{
			oleDbCommand_22 = new OleDbCommand(string_1, this.oleDbConnection_0);
			return oleDbCommand_22;
		}
		oleDbCommand_22.CommandText = string_1;
		return oleDbCommand_22;
	}
	public ArrayList method_4(string string_1, out string string_2)
	{
		OleDbDataReader oleDbDataReader = null;
		ArrayList result;
		try
		{
			ArrayList arrayList = new ArrayList();
			this.oleDbCommand_1 = this.method_38(this.oleDbCommand_1, string_1);
			oleDbDataReader = this.oleDbCommand_1.ExecuteReader();
			while (oleDbDataReader.Read())
			{
				arrayList.Add(new QQgroupinvite
				{
					id = oleDbDataReader["qid"].ToString(),
					qqgroup = oleDbDataReader["qqgroup"].ToString(),
					qq = oleDbDataReader["qq"].ToString(),
					inviteqq = oleDbDataReader["inviteqq"].ToString(),
					authadimqq = oleDbDataReader["authadimqq"].ToString(),
					ingroupflg = oleDbDataReader["ingroupflg"].ToString(),
					exitflg = oleDbDataReader["exitflg"].ToString(),
					deladmin = oleDbDataReader["deladmin"].ToString(),
					entertime = oleDbDataReader["entertime"].ToString(),
					exittime = oleDbDataReader["exittime"].ToString()
				});
			}
			string_2 = "";
			result = arrayList;
		}
		catch (Exception ex)
		{
			string_2 = ex.ToString();
			result = null;
		}
		finally
		{
			this.method_23(oleDbDataReader);
		}
		return result;
	}
	public ArrayList method_5(string string_1)
	{
		OleDbDataReader oleDbDataReader = null;
		ArrayList result;
		try
		{
			ArrayList arrayList = new ArrayList();
			this.oleDbCommand_2 = this.method_38(this.oleDbCommand_2, string_1);
			oleDbDataReader = this.oleDbCommand_2.ExecuteReader();
			while (oleDbDataReader.Read())
			{
				arrayList.Add(new GClass30
				{
					string_0 = oleDbDataReader["qq"].ToString(),
					string_1 = oleDbDataReader["cnt"].ToString()
				});
			}
			result = arrayList;
		}
		catch (Exception)
		{
			result = null;
		}
		finally
		{
			this.method_23(oleDbDataReader);
		}
		return result;
	}
	public ArrayList method_6(string string_1)
	{
		OleDbDataReader oleDbDataReader = null;
		ArrayList result;
		try
		{
			ArrayList arrayList = new ArrayList();
			this.oleDbCommand_3 = this.method_38(this.oleDbCommand_3, string_1);
			oleDbDataReader = this.oleDbCommand_3.ExecuteReader();
			while (oleDbDataReader.Read())
			{
				arrayList.Add(new GClass29
				{
					string_0 = oleDbDataReader["qqgroup"].ToString(),
					string_2 = oleDbDataReader["cnt"].ToString()
				});
			}
			result = arrayList;
		}
		catch (Exception)
		{
			result = null;
		}
		finally
		{
			this.method_23(oleDbDataReader);
		}
		return result;
	}
	public bool method_7(string string_1, out string string_2)
	{
		bool result;
		try
		{
			this.oleDbCommand_4 = this.method_38(this.oleDbCommand_4, string_1);
			this.oleDbCommand_4.ExecuteNonQuery();
			string_2 = "";
			result = true;
		}
		catch (Exception ex)
		{
			string_2 = ex.ToString();
			result = false;
		}
		return result;
	}
	public bool method_8(QQqun qq_qun, out string string_1)
	{
		bool result;
		try
		{
			string text = "insert into qqgroupmng(qqgroup, groupname, owner) values('{qqgroup}', '{groupname}', '{owner}');";
			text = text.Replace("{qqgroup}", qq_qun.num ?? "").Replace("{groupname}", qq_qun.name.Replace("'", "").Replace("\n", "").Replace("\t", "")).Replace("{owner}", qq_qun.owner);
			this.oleDbCommand_5 = this.method_38(this.oleDbCommand_5, text);
			this.oleDbCommand_5.ExecuteNonQuery();
			string_1 = "";
			result = true;
		}
		catch (Exception ex)
		{
			string_1 = ex.ToString();
			result = false;
		}
		return result;
	}
	public bool method_9(QQqun qq_qun)
	{
		bool result;
		try
		{
			string text = "update qqgroupmng set groupname='{groupname}', owner='{owner}' where qqgroup= '{qqgroup}';";
			text = text.Replace("{qqgroup}", qq_qun.num).Replace("{groupname}", qq_qun.name.Replace("'", "").Replace("\n", "").Replace("\t", "")).Replace("{owner}", qq_qun.owner);
			this.oleDbCommand_6 = this.method_38(this.oleDbCommand_6, text);
			this.oleDbCommand_6.ExecuteNonQuery();
			result = true;
		}
		catch
		{
			result = false;
		}
		return result;
	}
}
